
 <html> <head></head><body> 
 <table> <tr><td>DbVersionLogId </td><td>MajorReleaseNumber </td><td>MinorReleaseNumber </td><td>PointReleaseNumber </td><td>LastCodeUnitName </td><td>VersionNumber </td><td>AffectedDbObjName </td><td>Description </td></tr> 
<tr style="background-color:#C2DFFF" ><td>1 </td><td>0 </td><td>0 </td><td>2 </td><td>UNKONOWN </td><td>0.0.2.201003119 </td><td>UNKNOWN </td><td>Modeled AlVersion and DbVersion History Tables </td></tr> 
<tr><td>2 </td><td>0 </td><td>0 </td><td>2 </td><td>UNKONOWN </td><td>0.0.2.201003119 </td><td>UNKNOWN </td><td>Modeled AlVersionUddate Table </td></tr> 
<tr style="background-color:#C2DFFF" ><td>3 </td><td>0 </td><td>0 </td><td>2 </td><td>UNKONOWN </td><td>0.0.2.201003119 </td><td>UNKNOWN </td><td>Modeled Bug Table </td></tr> 
<tr><td>4 </td><td>0 </td><td>0 </td><td>2 </td><td>UNKONOWN </td><td>0.0.2.201003119 </td><td>UNKNOWN </td><td>Modeled DbVersionLogTable </td></tr> 
<tr style="background-color:#C2DFFF" ><td>5 </td><td>0 </td><td>0 </td><td>2 </td><td>UNKONOWN </td><td>0.0.2.201003119 </td><td>UNKNOWN </td><td>Modeled User Table </td></tr> 
<tr><td>6 </td><td>0 </td><td>0 </td><td>3 </td><td>UNKONOWN </td><td>0.0.3.201003120 </td><td>UNKNOWN </td><td>Modeled the following tables : 
MetaTable , User , Role , UserRole , AlVersionUpdate , AlVersionUpdateHistory , AppConstant , AppSetting , Bug , DbVersionLog , DbVersionLogHistory , Feature , Idea , MetaColumn , MetaParameter , PageInstance , PageInstanceController , Permissions , PermissionStateDesc , PlReports , PrincipleTypeDesc , tbGuiTabWizard </td></tr> 
<tr style="background-color:#C2DFFF" ><td>7 </td><td>0 </td><td>0 </td><td>4 </td><td>UNKONOWN </td><td>0.0.4.201003122 </td><td>UNKNOWN </td><td>Added MetaPkFkRelations table for  tracking and recreating FK's between the tables </td></tr> 
<tr><td>8 </td><td>0 </td><td>0 </td><td>4 </td><td>UNKONOWN </td><td>0.0.4.201003122 </td><td>UNKNOWN </td><td>Added Requirements table </td></tr> 
<tr style="background-color:#C2DFFF" ><td>9 </td><td>0 </td><td>0 </td><td>4 </td><td>UNKONOWN </td><td>0.0.4.201003122 </td><td>UNKNOWN </td><td>Changed SQL installation folder structure. Added levels for better handling of order of sql scripts execution. This avoids the adding of number of the scripts. A generatl rule could be : as soon as there are more than 7-10 sql scripts i a level_n numbered folder create a new folder. Observe that level_1 executes before level_2 </td></tr> 
<tr><td>10 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Added AlName table </td></tr> 
<tr style="background-color:#C2DFFF" ><td>11 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Added and populated Application Settings  table </td></tr> 
<tr><td>12 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Added Comments table </td></tr> 
<tr style="background-color:#C2DFFF" ><td>13 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Fix bugs in HIistory table sql generation </td></tr> 
<tr><td>14 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Fixed bugs to Table History tracking on insert , update and delete triggrers </td></tr> 
<tr style="background-color:#C2DFFF" ><td>15 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Removed PageInstance to Page , made it more simplier </td></tr> 
<tr><td>16 </td><td>0 </td><td>0 </td><td>7 </td><td>UNKONOWN </td><td>0.0.7.201003126 </td><td>UNKNOWN </td><td>Various improvements / code formatting in Generator stored utils </td></tr> 
<tr style="background-color:#C2DFFF" ><td>17 </td><td>0 </td><td>0 </td><td>8 </td><td>UNKONOWN </td><td>0.0.8.201003127 </td><td>UNKNOWN </td><td>Added Class Generation features. Added AppSettings , UserSettings </td></tr> 
<tr><td>18 </td><td>0 </td><td>1 </td><td>0 </td><td>UNKONOWN </td><td>0.1.0.20100331 </td><td>UNKNOWN </td><td>Added language info table. Added Msg table </td></tr> 
<tr style="background-color:#C2DFFF" ><td>19 </td><td>0 </td><td>1 </td><td>0 </td><td>UNKONOWN </td><td>0.1.0.20100331 </td><td>UNKNOWN </td><td>Added language info table. Added Msg table </td></tr> 
<tr><td>20 </td><td>0 </td><td>1 </td><td>0 </td><td>UNKONOWN </td><td>0.1.0.20100331 </td><td>UNKNOWN </td><td>Added stored proc for retrieving Global and Page Type messages </td></tr> 
<tr style="background-color:#C2DFFF" ><td>21 </td><td>0 </td><td>2 </td><td>4 </td><td>UNKONOWN </td><td>0.2.4.20100430 </td><td>UNKNOWN </td><td>Fixed bugs in LoadPageMetaData stored proc and LoadFormMetaData stored proc </td></tr> 
<tr><td>22 </td><td>0 </td><td>2 </td><td>5 </td><td>UNKONOWN </td><td>0.2.5.20100501 </td><td>UNKNOWN </td><td>Intoduced <version> tag in every object , the file name of the object starts with the number of installation . and the version. Thus different versions of the database objects could be tracked / or transfer between developers </td></tr> 
<tr style="background-color:#C2DFFF" ><td>23 </td><td>0 </td><td>2 </td><td>5 </td><td>UNKONOWN </td><td>0.2.5.20100501 </td><td>UNKNOWN </td><td>Added DebugDir property to he AppSettings and UserSettings table - indicates where to store logs for debugging </td></tr> 
<tr><td>24 </td><td>0 </td><td>2 </td><td>5 </td><td>UNKONOWN </td><td>0.2.5.20100502 </td><td>UNKNOWN </td><td>Added Example Table coctaining all the datatypes and the basic needed documentation for easier table building. </td></tr> 
<tr style="background-color:#C2DFFF" ><td>25 </td><td>0 </td><td>2 </td><td>5 </td><td>UNKONOWN </td><td>0.2.5.20100502 </td><td>UNKNOWN </td><td>Added UrlPararmPageType table - modelling the fact that each page  type might have 0 or more url parameters , but they all have to be registered to db. Each UrlParam might belong to 0 or more PageTypes </td></tr> 
<tr><td>26 </td><td>0 </td><td>2 </td><td>5 </td><td>UNKONOWN </td><td>0.2.5.20100502 </td><td>UNKNOWN </td><td>Added modelling for UrlParmeter value. One UrlParameter might have 0 or more UrlParameter values. One UrlParameter Value might belong to 0 or more UrlParams </td></tr> 
<tr style="background-color:#C2DFFF" ><td>27 </td><td>0 </td><td>2 </td><td>7 </td><td>UNKONOWN </td><td>0.2.7.20100504 </td><td>UNKNOWN </td><td>Added property for HasEventHandling in MetaParameter. Added isDeleted query in LoadFormMeta stored proc and order by orderId </td></tr> 
<tr><td>28 </td><td>0 </td><td>3 </td><td>2 </td><td>UNKONOWN </td><td>0.3.2.20100509 </td><td>UNKNOWN </td><td>Created script for creation of test tables for all sql server 2008 datatypes- each table contains only one column of a particular data type + a pk column of type bigint </td></tr> 
<tr style="background-color:#C2DFFF" ><td>29 </td><td>0 </td><td>3 </td><td>2 </td><td>UNKONOWN </td><td>0.3.2.20100509 </td><td>UNKNOWN </td><td>Created script for creation of test generated stored procedures for insert action based on the TestDataTypeTables </td></tr> 
<tr><td>30 </td><td>0 </td><td>4 </td><td>2 </td><td>UNKONOWN </td><td>0.4.2.20100509 </td><td>UNKNOWN </td><td>Created deployment packages for sql shema. Deployment packages are fully configurable for host and database name and work on configure once , run on msingle click n times </td></tr> 
<tr style="background-color:#C2DFFF" ><td>31 </td><td>0 </td><td>5 </td><td>0 </td><td>UNKONOWN </td><td>0.5.0.20100828_234953 </td><td>UNKNOWN </td><td>Fixed bug for majority of sql objects non deployment due for dependancies, now the majority of the objects are deployed yet the logical units are to be defined more. Created Import from csv subproject (Needs probably foreign keys removal and readding) </td></tr> 
<tr><td>32 </td><td>0 </td><td>5 </td><td>1 </td><td>UNKONOWN </td><td>0.5.1.20100904_142557 </td><td>UNKNOWN </td><td>Concept for printing each script file run + conducting test for table create </td></tr> 
<tr style="background-color:#C2DFFF" ><td>33 </td><td>0 </td><td>5 </td><td>2 </td><td>UNKONOWN </td><td>0.5.2.20100905_214745 </td><td>UNKNOWN </td><td>Uncommented txt -> sql several tables , Requirement , Task , Process etc. </td></tr> 
<tr><td>34 </td><td>0 </td><td>5 </td><td>3 </td><td>UNKONOWN </td><td>0.5.3.20100909_215832 </td><td>UNKNOWN </td><td>Created cmd files for DEV , TEST , QA and prod databases. Improved ReadMe file </td></tr> 
<tr style="background-color:#C2DFFF" ><td>35 </td><td>0 </td><td>5 </td><td>4 </td><td>UNKONOWN </td><td>0.5.4.20100911_222357 </td><td>UNKNOWN </td><td>Added couple of generators, fixed bug with installer cmds </td></tr> 
<tr><td>36 </td><td>0 </td><td>5 </td><td>5 </td><td>DbVersionLog.TableCreate.sql </td><td>0.5.5.20100911_222357 </td><td>UNKNOWN </td><td>Changed the named of the DbVersionUpdate to DbVersionLog -- added int version numbering </td></tr> 
<tr style="background-color:#C2DFFF" ><td>37 </td><td>0 </td><td>5 </td><td>6 </td><td>AlVersionLog.TableCreate.sql </td><td>0.5.6.20100918_214154 </td><td>AlVersionLog </td><td>Removed the AlVersionUpdate + HIstory table + triggers and readded the AllVersionLog , which does have a better versionning model, Created also AlVersionLog.InsertTable.sql from old data </td></tr> 
<tr><td>38 </td><td>0 </td><td>5 </td><td>7 </td><td>UserRole.TableCreate.sll </td><td>0.5.7.20100919_195507 </td><td>UserRole </td><td>Changed UserId and RoleId columns to UserKey and RoleKey to adopt to a new naming convention where Id is the PK and Key is the FK </td></tr> 
<tr style="background-color:#C2DFFF" ><td>39 </td><td>0 </td><td>5 </td><td>8 </td><td>Person.TableCreate </td><td>0.5.8.20100919_215416 </td><td>Person </td><td>Created separate table for Person and System Accounts </td></tr> 
<tr><td>40 </td><td>0 </td><td>5 </td><td>9 </td><td>MetaColumn.TableCreate </td><td>0.5.9.20101023_232611 </td><td>MetaColumn </td><td>Created MetaColumn table. Purpose to separate the logic of the meta data with the gui data. Thus the application layer will join those in to a single model entity for "quark" containing the model data of one control </td></tr> 
<tr style="background-color:#C2DFFF" ><td>41 </td><td>0 </td><td>6 </td><td>0 </td><td>DbVersion.TableCreate </td><td>0.6.0.20101223_21254 </td><td>DbVersion </td><td>Created DbRole table. Role should stand for business role. One business role could have (interpolate into ) one or many DbRoles </td></tr> 
<tr><td>42 </td><td>0 </td><td>6 </td><td>0 </td><td>UserDbRole.TableCreate </td><td>0.6.0.20101223_21254 </td><td>UserDbRole </td><td>Creation and population of the UserDbRole. Answer to the question which user to which database role does belong </td></tr> 
<tr style="background-color:#C2DFFF" ><td>43 </td><td>0 </td><td>6 </td><td>1 </td><td>02.ForeignKeysHandlinng </td><td>0.6.1.20101226_131310 </td><td>many </td><td>Added the feature to be able to first all foreign keys or their creation codes , remove them , populate table and readd all the foreign keys in the database </td></tr> 
<tr><td>44 </td><td>0 </td><td>6 </td><td>2 </td><td>various </td><td>0.6.2.20101227_162239 </td><td>many </td><td>Added MetaGuiTable , MetaGuiColumn , BugStatus , RequirementStatus </td></tr> 
<tr style="background-color:#C2DFFF" ><td>45 </td><td>0 </td><td>6 </td><td>3 </td><td>many </td><td>0.6.3.20101227_224129 </td><td>many </td><td>Added new translation strategy - tables - TxtDev , Txt + small proof of concept for getting a translated message </td></tr> 
<tr><td>46 </td><td>0 </td><td>6 </td><td>4 </td><td>procUtils_GenerateModelClass </td><td>0.6.4.20110102_71348 </td><td>many </td><td>Fixed bugs in Model class generation </td></tr> 
<tr style="background-color:#C2DFFF" ><td>47 </td><td>0 </td><td>6 </td><td>7 </td><td>procUtils_GenerateModelClass </td><td>0.6.7.20110108_112400 </td><td>many </td><td>Fixed bugs in Model class generation for constructor and Load data </td></tr> 
<tr><td>48 </td><td>0 </td><td>6 </td><td>8 </td><td>many </td><td>0.6.8 </td><td>many </td><td>Added template Generator in perl ... Ability to generate code based on templates and an input Excel </td></tr> 
<tr style="background-color:#C2DFFF" ><td>49 </td><td>0 </td><td>6 </td><td>9 </td><td>many </td><td>0.6.9 </td><td>many </td><td>Implemented logical environments based on project name , system version , environment type and env owner </td></tr> 
<tr><td>50 </td><td>0 </td><td>7 </td><td>0 </td><td>many </td><td>0.7.0 </td><td>many </td><td>Added perl Excel to MSSQL sql. Ability to retrieve data from db into Excel and insert it back </td></tr> 
<tr style="background-color:#C2DFFF" ><td>51 </td><td>0 </td><td>7 </td><td>1 </td><td>many </td><td>0.7.1 </td><td>many </td><td>Added NSI installers for deployment of the application </td></tr> 
<tr><td>52 </td><td>0 </td><td>7 </td><td>2 </td><td>ExcelToMSSQL </td><td>0.7.2 </td><td>ExcelToMSSQL </td><td>Single call generation of MSSQL scripts from an Excel file by using the first row of the Excel as the column list and the sheet name as the table name </td></tr> 
<tr style="background-color:#C2DFFF" ><td>53 </td><td>0 </td><td>7 </td><td>2 </td><td>ExcelToMSSQL </td><td>0.7.3.1 </td><td>ExcelToMSSQL.0.4.0 </td><td>The insert files are generated straight in to the sql install package directory </td></tr> 
<tr><td>54 </td><td>0 </td><td>7 </td><td>3 </td><td>DeploymentPackage </td><td>0.7.3.2 </td><td>ExcelToMSSQL.0.4.0 </td><td>A cmd script added which enables a single click zipping of the whole deployment package into a single zip file </td></tr> 
<tr style="background-color:#C2DFFF" ><td>55 </td><td>0 </td><td>7 </td><td>4 </td><td>GenerateSelectAll </td><td>0.7.4.1 </td><td>GenerateSelectAll.0.1.0 </td><td>Ability to generate select all foreach db, schema   ,table </td></tr> 
<tr><td>56 </td><td>0 </td><td>7 </td><td>4 </td><td>GenerateSelectAllOrderBy1Desc </td><td>0.7.4.2 </td><td>GenerateSelectAllOrderBy1Desc.0.1.0 </td><td>Ability to generate select all foreach db, schema   ,table order by 1 desc </td></tr> 
<tr style="background-color:#C2DFFF" ><td>57 </td><td>0 </td><td>7 </td><td>4 </td><td>viewGen_SelectAll </td><td>0.7.4.3 </td><td>viewGen_SelectAll.0.1.0 </td><td>Ability to generate select all from table view </td></tr> 
<tr><td>58 </td><td>0 </td><td>7 </td><td>4 </td><td>etl export </td><td>0.7.4.4 </td><td>etl export </td><td>Ability to export any data from any sql file </td></tr> 
</table> 
</body></html> 
